1-Mean Hypothesis Testing:

The data you need to do such a test is:

\[\text{Null Hypothesis: }H_0:\mu=?\]

\[\text{Sample Size: }n\]

\[\text{Standard Deviation: }\sigma\text{ or }s\]

\[\text{Sample mean: }\overline{x}\]

\[\text{level of significance: }\alpha\]

Example: Say we had an example that gave us:

\[H_0:\mu=200\]

\[n=35\]

\[\overline{x}=220\]

\[\sigma=100\]

\[\alpha=0.05\]

We then would just enter this into our Excel Sheet besides the appropriate name in the column labeled "Enter values" in the box for "1-Mean" (highlighted in green)

as shown in the picture!

*Note in the newest version the excel sheet asks for variance instead of standard deviation!!*

2-Mean Hypothesis Testing:

The data you need to do such a test is:

\[\text{Null Hypothesis: }H_0:\mu_1-\mu_2=??\]

\[\text{Sample Size 1: }n_1\]

\[\text{Sample Size 2:}n_2\]

\[\text{Standard Deviation 1: }\sigma_1\text{ or }s_1\]

\[\text{Standard Deviation 2: }\sigma_2\text{ or }s_2\]

\[\text{Sample mean 1: }\overline{x}_1\]

\[\text{Sample mean 2:}\overline{x}_2\]

\[\text{level of significance: }\alpha\]

Example: Say we had an example that gave us:

\[H_0:\mu_1-\mu_2=0\]

\[n_1=35\]

\[n_2=40\]

\[\overline{x}_1=220\]

\[\overline{x}_2=180\]

\[\sigma_1=100\]

\[\sigma_2=95\]

\[\alpha=0.05\]

We then would just enter this into our Excel Sheet besides the appropriate name in the column labeled "Enter values" in the box for "2-Mean" (highlighted in red)

as shown in the picture!

You do it similarly for the confidence interval box!